CREATE PROCEDURE [dbo].[sp_cat_AddDistributor]
@Distributor varchar(50), @UserUpdater int
WITH EXEC AS CALLER
AS
BEGIN
  BEGIN TRAN A
  INSERT INTO CT_Distributor(Distributor,UpdatedBy)
  VALUES(@Distributor , @UserUpdater );
  IF @@ERROR<>0 BEGIN
    ROLLBACK TRAN A
  END
  COMMIT TRAN A
END